
******************************************************
*                   Replication files                *
*         Review of Economics and Statistics         *
*                                                    *
*               Jam Barrel Politics                  *
*                                                    *
*                      Authors:                      *
*    Leonardo Bonilla-Mejia & Juan S. Morales        *
*                                                    *
*                   November 2021                    *
*                                                    *
******************************************************


This folder contains replication data and code to generate tables and figures for the paper.

*******************
Organization: Files are arranged into four folders

- do: contains do files that clean the data, estimate the models and generate tables and figures.  

- data: contains cleaned data used for regressions, tables, and figures.

- Results: contains result output files.

- original_data: contains original data files. 

*******************
Software: Stata/SE 15 (version 15.0) for Windows

*******************
Instructions for replication: In each do file you must specify the path for the
main folder setting the current directory (cd). 

*******************
List of do files:

> do/data.do
Code processing and cleaning original data from multiple sources for estimations, tables, and figures.

> do/tables_figures.do
Code generating main tables and figures.

> do/appendix_tables_figures.do
Code generating appendix tables and figures.

*******************
List of data files in folder data: 

> data/properidad_vias_HR.dta
Cleaned data for road projects generated by data.do.

> data/congresoList_wV_des.dta
Cleaned data for congressman generated by data.do.

> data/congressionalVotes_roads.dta
Cleaned data for congressional votes and road projects generated by data.do.

> data/municipal_characteristics.dta
Cleaned data for municipal characteristics generated by data.do.

> data/department_characteristics.dta
Cleaned data for department characteristics generated by data.do.

> data/noaa_roads.dta
Cleaned data for night lights and roads generated by data.do.

> data/NL_rti.dta
Cleaned data for return on investment generated by data.do.

> data/PAindeces.dta
Cleaned data for political alignment by congressman generated by data.do.

> data/congressionalVotes_dept.dta
Cleaned data for congressional votes and departament-level oad projects generated by data.do.

> data/congresoList_birth.dta
Cleaned data for congressman department of birth generated by data.do.

> data/mermelada_politica_trends.dta
Cleaned data for Google search volume for "mermerlada política" generated by data.do.

*******************
List of data files in folder original_data: 

> original_data/1.3.2.6.IPP_Serie histórica según uso o destino económico.xlsx
Original data for Producer price index from Banco de la Republica (construction materials)
> original_data/Congresistas_invest.xlsxOriginal data for Supreme court investigation by congressman (from press)

> original_data/congreso_2010_aspirantes_2014.dta
Original data for congressman running and elected in 2014 (from CEDE)
> original_data/congresoList_gender.dtaOriginal data for congressman's gender (own classification)

> original_data/conTodoslist.csvOriginal data for congressman characteristics (from Congreso Visible)
> original_data/conTodoslist_wV.csv
Original data for congressman additional characteristics (from Congreso Visible)
> original_data/dependencia_20102012_dpto.dtaOriginal data for department fiscal dependency (computed using budget execution data from DNP)

> original_data/dependencia_20102012_mun.dtaOriginal data for municipal fiscal dependency (computed using budget execution data from DNP)

> original_data/dpto_peri.xlsx
Original data for department classification (own classification)
> original_data/geo_mun.dta
Original data for municipal altitude, slope, roughness, and tri (computed using data from the Digital Elevation Model)
> original_data/homicidio.dtaOriginal data for municipal homicide rate (computed using data from National Police)

> original_data/iga_itep.dta
Original data for municipal Open Government and Transarency Indexes (computed using data from Inspector General of Colombia and Transparencia por Colombia) 

> original_data/invias_codmun.csv
Original data for Terciary road projects (from INVIAS)
> original_data/mermelada_politica_trends.csvOriginal data for volume of Google searches for "mermelada política" (from Google trends)

> original_data/noaa.dta
Original data for night lights (computed using data from NOAA)
> original_data/PANEL_CARACTERISTICAS_GENERALES.dta
Original data for municipal characteristics (from CEDE)
> original_data/Partidos_Coalicion.dta
Original data for government coalition (from Bonilla-Mejia & Higuera-Mendieta, 2017)
> original_data/pib_dpto_sect.dtaOriginal data for department GDP by sector (computed using data from DANE)
> original_data/prosperidad_convenio.dta
Original data for Terciary road contracts (from INVIAS)
> original_data/prosperidad_HR.csvOriginal data for Terciary road sponsors (created using data from INVIAS and leaked data)
> original_data/road_mun.dta
Original data for road density (computed using data from National Geographic Institute and DANE)
> original_data/SABER11_2010.dtaOriginal data for exit exam (SABER 11) test scores (computed using data from ICFES)

> original_data/SECOP_invias.dta
Original data for road contracts of INVIAS in the Public Procurement Registry (SECOP) (from SECOP)
> original_data/twitter_mermelada.dtaOriginal data for congressman's tweets mentioning political jam  (from Twitter)

> original_data/votesAData.csv
Original data for congressional votes (from Congreso Visible)
> original_data/votesIData.csv
Original data for congressional votes (from Congreso Visible)

*******************
List of tables and figures in folder results:

* Main tables and figures
figure_2_core.pngfigure_2_peri.pngfigure_3.pngfigure_4_core.pngfigure_4_peri.png
table_1.textable_2.textable_3.textable_4.textable_5.tex


* Appendix tables and figurestable_A1.textable_A2.textable_A3.textable_A4.textable_A5.textable_A6.textable_A7.textable_A8.textable_A9.textable_A10.textable_A11.textable_A12.textable_A13.textable_A14.textable_A15.textable_A16_core.textable_A16_peri.textable_A17_core.textable_A17_peri.textable_A18_core.textable_A18_peri.textable_A19.textable_A20.textable_A21.textable_A22.textable_A23_TR.textable_A23.textable_A24.tex 
figure_A1.pngfigure_A4.pngfigure_A5_iga.pngfigure_A5_ITEP.png
Postb_valor_n_1m_short.pngPostb_valor_n_3m_short.pngPostiga_1m_short.pngPostiga_3m_short.pngPostindepe_f_1m_short.pngPostindepe_f_3m_short.pngPostITEP_1m_short.pngPostITEP_3m_short.pngPostlog_road_pc_1m_short.pngPostlog_road_pc_3m_short.pngPostlog_road_pkm2_1m_short.pngPostlog_road_pkm2_3m_short.pngPostnbi_1m_short.pngPostnbi_3m_short.pngfigure_A8.pngfigure_A9.pngfigure_A10.pngfigure_A11.png
